/*
 * structs.  The purpose of these classes is to seperate sql code from the Swing
 * code.  Otherwise, you'd be processing resultsets in the front-end logic, which is 
 * not completely understood, so we need to avoid tangling it up
 * 
 */
package healthcare;

/**
 *
 * @author Doug Keeley
 */
public class Entities {
}

class CareGiver {
    public String CAREGIVERID;   		 //NOT NULL NUMBER        
    public String FIRSTNAME;              //VARCHAR2(100) 
    public String MIDDLEINIT;             //CHAR(1)       
    public String LASTNAME;               //VARCHAR2(100) 
    public String STREET;                 //VARCHAR2(100) 
    public String CITY;                   //VARCHAR2(100) 
    public String STATE;                  //VARCHAR2(100) 
    public String SEX;                    //CHAR(1)       
    public String EMAIL;                  //VARCHAR2(100) 
    public String DATEOFBIRTH;            //DATE          
    public String PHONE;                  //VARCHAR2(100) 
    public String ZIPCODE;                //VARCHAR2(100) 
    public String HOURLYPAYRATE;          //NUMBER(6,2)
}   

class Client {     
    public String CLIENTSSN; 		//VARCHAR2(9 BYTE), 
    public String FIRSTNAME; 		//VARCHAR2(100 BYTE), 
    public String MIDDLEINIT; 		//CHAR(1 BYTE), 
    public String LASTNAME; 		//VARCHAR2(100 BYTE), 
    public String STREET;			//VARCHAR2(100 BYTE), 
    public String CITY; 			//VARCHAR2(100 BYTE), 
    public String STATE; 			//VARCHAR2(100 BYTE), 
    public String PHONE; 			//VARCHAR2(100 BYTE), 
    public String SEX;				//CHAR(1 BYTE), 
    public String EMAIL; 			//VARCHAR2(100 BYTE), 
    public String ZIPCODE; 			//VARCHAR2(100 BYTE)
}

class ScheduledVisit {
    public String CLIENTSSN;	   //VARCHAR2(9 BYTE), 	
    public String DATEOFVISIT;	   //DATE, 
    public String CAREGIVERID;	   //NUMBER, 
    public String TYPEOFCARE;	   //VARCHAR2(100 BYTE), 	
    public String TIMESTARTED;	   //DATE, 
    public String TIMEENDED;	   //DATE, 
    public String INVOICENUMBER;   //NUMBER
    
    public CareGiver careGiver;  //optional related record
}

class CaseWorker {
    public String CASEWORKERID; 		//NUMBER, 
    public String FIRSTNAME; 			//VARCHAR2(100 BYTE), 
    public String MIDDLEINIT;			//CHAR(1 BYTE), 
    public String LASTNAME; 			//VARCHAR2(100 BYTE), 
    public String STREET;                       //VARCHAR2(100 BYTE), 
    public String CITY; 			//VARCHAR2(100 BYTE), 
    public String STATE; 			//VARCHAR2(100 BYTE), 
    public String SEX; 				//CHAR(1 BYTE), 
    public String PHONE; 			//VARCHAR2(20 BYTE), 
    public String ZIPCODE; 			//VARCHAR2(100 BYTE), 
    public String NAMEOFINSURER; 		//VARCHAR2(100 BYTE)
}

class Insured {
    public String CLIENTSSN;                    //NOT NULL VARCHAR2(9)   
    public String CASEWORKERID;                 //NOT NULL NUMBER        
    public String INSURANCENUMBER;              //VARCHAR2(100) 
    public String ISPRIMARY;                    //CHAR(1)       
    public String HOURLYBILLRATE;                //NUMBER(6,2)  
    
    public CaseWorker caseWorker;  //optional related record 
}

